Development of Efficient Temporal Databases in a Real time

This paper presents description of real time database system. Like conventional database, real time data-base system must handle transactions with timing constraint. Real-time database systems must maintain both logical and temporal data integrity so that transactions can respond to real-world events timely and predictably. This paper, first presents concurrency control mechanism including various techniques for achieving serializability and improving performance. It illustrates a concurrency control algorithm for accessing to temporal data model in real-time database. The concurrency control algorithm improves the performance of real-time systems by evaluating data-deadline and transactions execution time, adjusting transaction validation rule and committing order. The new concurrency control strategy for DRTDBS is improved 2PL-HP protocol. This paper also Define the concept of absolute and relative temporal consistency from the perspective of transactions for discrete data objects. And discuss how a real-time database system should be designed to enforce different levels of temporal consistency. And also the concept of data-deadline is introduced and time cognizant transaction scheduling policies, forced wait policies are proposed. Also examine the implications of using run policies to better utilize real-time scheduling in a data base environment. To improve performance of real time database system by avoiding unnecessary restart of transaction “OCCDATI”(optimistic concurrency control with dynamic adjustment using timestamp intervals) method propose.